[dbo].[BAEEventCheckRegistrantStatus]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEEventCheckRegistrantStatus

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@userID	varchar(10)	10
@eventCode	varchar(10)	10

SQL Script

create procedure [dbo].[BAEEventCheckRegistrantStatus] @userID varchar(10),
@eventCode varchar(10) as
SELECT * FROM Orders o, Order_Meet om
WHERE ST_ID = @userID AND o.ORDER_NUMBER = om.ORDER_NUMBER AND MEETING = @eventCode;

GO

Uses

[dbo].[Order_Meet]
[dbo].[Orders]
dbo